{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["Summary","Anex D 1_PTA","Anex D.2_ JHB","Anex D.3_DUR","Anex D.4_ Rosebank","Anex D.5_Stellenbosch"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Summary","index":0,"n_rows":20,"n_cols":9,"rows_kept":20,"merged":[[3,0,3,8],[4,3,4,4],[4,5,4,6],[4,7,4,8],[9,0,9,2],[10,0,10,2],[11,0,11,2],[13,0,13,8],[17,0,17,3],[18,0,18,3],[19,0,19,3]]}
["The provision of water management services to the CSIR  for a period of three (3) years"]
[]
[]
["Section Total Costings"]
[{"$nulls":3},"Year 1",null,"Year 2",null,"Year 3"]
["Description/Trade","Unit","Quantity ","Rate per month","Total","Rate per month","Total","Rate per month","Total"]
[" Year 1  Management  fees\nIncludes;\nReporting (As per section 3.1 of the RFQ\nOperations/Technical Support  (As per section 3.1 of the RFP)","monthly",12,null,{"$f":"D7*C7","v":0},null,{"$f":"F7*C7","v":0},null,{"$f":"H7*C7","v":0}]
[" Year 2  Management  fees\nIncludes;\nReporting (As per section 3.1 of the RFQ\nOperations/Technical Support  (As per section 3.1 of the RFP)","monthly",12,null,{"$f":"D8*C8","v":0},null,{"$f":"F8*C8","v":0},null,{"$f":"H8*C8","v":0}]
[" Year 3  Management  fees\nIncludes;\nReporting (As per section 3.1 of the RFQ\nOperations/Technical Support  (As per section 3.1 of the RFP)","monthly",12,null,0,null,0,null,0]
[{"$nulls":3},"Sub Total",{"$f":"SUM(E7:E9)","v":0},"Sub Total",{"$f":"SUM(G7:G9)","v":0},"Sub Total",{"$f":"SUM(I7:I9)","v":0}]
[{"$nulls":3},"15% VAT",{"$f":"E10*0.15","v":0},"15% VAT",{"$f":"G10*0.15","v":0},"15% VAT",{"$f":"I10*0.15","v":0}]
[{"$nulls":3},"Grand Total",{"$f":"SUM(E10:E11)","v":0},"Grand Total",{"$f":"SUM(G10:G11)","v":0},"Grand Total",{"$f":"SUM(I10:I11)","v":0}]
[]
[]
["Description/Trade","Unit","Quantity ","Rate per unit","Total"]
["Testing, configuration and linking of devices to the new platform","sum",{"$f":"('Anex D 1_PTA'!C98+'Anex D.2_ JHB'!C10+'Anex D.3_DUR'!C10+'Anex D.4_ Rosebank'!C12+'Anex D.5_Stellenbosch'!C13)","v":97},null,{"$f":"D16*C16","v":0}]
["Safety File","item",1,null,{"$f":"D17*C17","v":0}]
["Sub Total",{"$nulls":3},{"$f":"SUM(E16:E17)","v":0}]
["15% VAT",{"$nulls":3},{"$f":"E18*0.15","v":0}]
["Grand Total",{"$nulls":3},{"$f":"SUM(E18:E19)","v":0}]

{"sheet":"Anex D 1_PTA","index":1,"n_rows":201,"n_cols":5,"rows_kept":201}
["The provision of water management services to the CSIR  for a period of three (3) years"]
["CSIR - Pretoria"]
[]
[]
["Description","Unit","Qty","Rate","Total"]
["Testing, configuration and linking of devices to the new platform"]
[]
["CSIR-Pta-Tennis CourtMeter No.10635123","sum",1,null,{"$f":"C8*D8","v":{"v":0,"d":"R0.00"}}]
["CSIR-Pta-Swimming PoolMeter No.110036575","sum",1,null,{"$f":"C9*D9","v":{"v":0,"d":"R0.00"}}]
["CSIR-Pta-Squash CourtMeter No.46325992","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Reservoir medium level OutletMeter No.14787486","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Reservoir medium level InletMeter No.15800874","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Reservoir low level outletMeter No.14787490","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Reservoir low level InletMeter No.15800871","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Main Incomer No.2Meter No.116289","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Main IncomerMeter No.16788837","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Main Entrance Control RoomMeter No.49325135","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Entabeni Single Quarters 9 - 10Meter No.150029778","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Entabeni Single Quarters 7 - 8Meter No.150029774","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Entabeni Single Quarters 5 - 6Meter No.150029775","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Entabeni Single Quarters 3 - 4Meter No.150029765","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Entabeni Single Quarters 11 - 12Meter No.150029771","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Entabeni Single Quarters 1 - 2Meter No.150029767","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Entabeni LaundryMeter No.150029766","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Entabeni KitchenMeter No.150029761","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building20Meter No.16710547","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 39 ICCMeter No.180381979","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 33Meter No.171279150","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-046AB-Building 46 A_BMeter No.15723497","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-043East-Building 43Meter No.15723504","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-042AB-Main IncomerMeter No.15723884","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-014F-Building 14FMeter No.200425927","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-014E-Building 14EMeter No.170772753","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-014B-Building 14 BMeter No.15789582","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-009-Main IncomerMeter No.15789612","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-009-Entabeni 9Meter No.150029777","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-008-Main IncomerMeter No.15789519","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-008-Entabeni 8Meter No.150029773","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-007-Main IncomerMeter No.15789611","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-007-Entabeni 7Meter No.46309733","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-006-Main IncomerMeter No.15789847","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-006-Entabeni 6Meter No.150029763","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-005-Main IncomerMeter No.15789849","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-005-Entabeni 5Meter No.150029754","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0053-Main IncomerMeter No.15789521","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-004-Main IncomerMeter No.15789852","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-004-Building 44Meter No.14787482","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0045-Building 45Meter No.170772752","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0041-Main IncomerMeter No.13128494","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-003-Entabeni 3Meter No.150029768","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0038-Building 38 Europa CarsMeter No.170772771","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0037-Main IncomerMeter No.15791965","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0036-Main IncomerMeter No.15789969","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0035-Toilet kitchenMeter No.C-JHB4189","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0035-Main  kitchenMeter No.C-JHB4188","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0034-Building 34Meter No.15723496","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0030-Building 30Meter No.RM-120528817","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-003_2-Main Incomer2Meter No.16710549","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-003_1-Main Incomer1Meter No.16710552","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-002-Main Incomer1Meter No.15789585","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-002-Entabeni 2Meter No.150029779","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0029Quadros-Building 32Meter No.49325151","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0028-Building 28Meter No.47344750","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0026-Building 26Meter No.47344748","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0025-Building 25Meter No.47344756","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0024-Building 24Meter No.1610635093","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0023-Main IncomerMeter No.16710545","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0022-Main IncomerMeter No.15789854","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0021-Building 21Meter No.15789583","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0020-Main IncomerMeter No.16710550","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0020Greenhouse-Main IncomerMeter No.15789610","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0020-GreenhouseMeter No.170772747","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-001-Entabeni 1Meter No.150029772","sum",1,null,{"$f":"C73*D73","v":{"v":0,"d":"R0.00"}}]
["CSIR-Pta-0018-Main IncomerMeter No.15789857","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0017-Main IncomerMeter No.15789617","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0016-Main Incomer1Meter No.15789620","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0016-Building 16Meter No.170772787","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0015-Building 15Meter No.15789842","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0013-Entabeni 13Meter No.150029780","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0013-Building 13Meter No.15789841","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0012-Main Incomer1Meter No.15789588","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0012-Entabeni 12Meter No.47344818","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0012-Building 12Meter No.15789587","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0011-Main IncomerMeter No.15789850","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0011-Entabeni 11Meter No.47344752","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0010-Main IncomerMeter No.15789851","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0010-Entabeni 10Meter No.150029762","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR_Pta_Water TreatmentMeter No.15789523","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR_Pta_004_Entabeni 4Meter No.150029776","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR_Pta_002_Building 2CMeter No.15791962","sum",1,null,{"$f":"C90*D90","v":{"v":0,"d":"R0.00"}}]
["CSIR_Building49Meter No.47344755","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR_Building32Meter No.1510531777","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR_Building27Meter No.170772779","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR_Building24Meter No.47344754","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR_Building19Meter No.200425920","sum",1,null,{"v":0,"d":"R0.00"}]
["CSIR_046FMeter No.15723503","sum",1,null,{"v":0,"d":"R0.00"}]
[]
["Sub Total",null,{"$f":"SUM(C8:C96)","v":89},null,{"$f":"SUM(E8:E96)","v":{"v":0,"d":"R0.00"}}]
[]
[]
["Monthly Subscription fees (12x 3years)"]
[]
["CSIR-Pta-Tennis CourtMeter No.10635123","monthly",{"$f":"12*3","v":36},null,{"$f":"C103*D103","v":{"v":0,"d":"R0.00"}}]
["CSIR-Pta-Swimming PoolMeter No.110036575","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Squash CourtMeter No.46325992","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Reservoir medium level OutletMeter No.14787486","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Reservoir medium level InletMeter No.15800874","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Reservoir low level outletMeter No.14787490","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Reservoir low level InletMeter No.15800871","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Main Incomer No.2Meter No.116289","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Main IncomerMeter No.16788837","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Main Entrance Control RoomMeter No.49325135","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Entabeni Single Quarters 9 - 10Meter No.150029778","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Entabeni Single Quarters 7 - 8Meter No.150029774","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Entabeni Single Quarters 5 - 6Meter No.150029775","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Entabeni Single Quarters 3 - 4Meter No.150029765","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Entabeni Single Quarters 11 - 12Meter No.150029771","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Entabeni Single Quarters 1 - 2Meter No.150029767","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Entabeni LaundryMeter No.150029766","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Entabeni KitchenMeter No.150029761","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building20Meter No.16710547","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 39 ICCMeter No.180381979","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-Building 33Meter No.171279150","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-046AB-Building 46 A_BMeter No.15723497","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-043East-Building 43Meter No.15723504","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-042AB-Main IncomerMeter No.15723884","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-014F-Building 14FMeter No.200425927","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-014E-Building 14EMeter No.170772753","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-014B-Building 14 BMeter No.15789582","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-009-Main IncomerMeter No.15789612","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-009-Entabeni 9Meter No.150029777","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-008-Main IncomerMeter No.15789519","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-008-Entabeni 8Meter No.150029773","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-007-Main IncomerMeter No.15789611","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-007-Entabeni 7Meter No.46309733","monthly",36,null,{"$f":"C135*D135","v":{"v":0,"d":"R0.00"}}]
["CSIR-Pta-006-Main IncomerMeter No.15789847","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-006-Entabeni 6Meter No.150029763","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-005-Main IncomerMeter No.15789849","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-005-Entabeni 5Meter No.150029754","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0053-Main IncomerMeter No.15789521","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-004-Main IncomerMeter No.15789852","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-004-Building 44Meter No.14787482","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0045-Building 45Meter No.170772752","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0041-Main IncomerMeter No.13128494","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-003-Entabeni 3Meter No.150029768","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0038-Building 38 Europa CarsMeter No.170772771","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0037-Main IncomerMeter No.15791965","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0036-Main IncomerMeter No.15789969","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0035-Toilet kitchenMeter No.C-JHB4189","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0035-Main  kitchenMeter No.C-JHB4188","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0034-Building 34Meter No.15723496","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0030-Building 30Meter No.RM-120528817","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-003_2-Main Incomer2Meter No.16710549","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-003_1-Main Incomer1Meter No.16710552","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-002-Main Incomer1Meter No.15789585","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-002-Entabeni 2Meter No.150029779","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0029Quadros-Building 32Meter No.49325151","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0028-Building 28Meter No.47344750","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0026-Building 26Meter No.47344748","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0025-Building 25Meter No.47344756","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0024-Building 24Meter No.1610635093","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0023-Main IncomerMeter No.16710545","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0022-Main IncomerMeter No.15789854","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0021-Building 21Meter No.15789583","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0020-Main IncomerMeter No.16710550","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0020Greenhouse-Main IncomerMeter No.15789610","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0020-GreenhouseMeter No.170772747","monthly",{"$f":"12*3","v":36},null,{"$f":"C167*D167","v":{"v":0,"d":"R0.00"}}]
["CSIR-Pta-001-Entabeni 1Meter No.150029772","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0018-Main IncomerMeter No.15789857","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0017-Main IncomerMeter No.15789617","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0016-Main Incomer1Meter No.15789620","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0016-Building 16Meter No.170772787","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0015-Building 15Meter No.15789842","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0013-Entabeni 13Meter No.150029780","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0013-Building 13Meter No.15789841","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0012-Main Incomer1Meter No.15789588","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0012-Entabeni 12Meter No.47344818","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0012-Building 12Meter No.15789587","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0011-Main IncomerMeter No.15789850","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0011-Entabeni 11Meter No.47344752","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0010-Main IncomerMeter No.15789851","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR-Pta-0010-Entabeni 10Meter No.150029762","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR_Pta_Water TreatmentMeter No.15789523","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR_Pta_004_Entabeni 4Meter No.150029776","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR_Pta_002_Building 2CMeter No.15791962","monthly",36,null,{"$f":"C185*D185","v":{"v":0,"d":"R0.00"}}]
["CSIR_Building49Meter No.47344755","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR_Building32Meter No.1510531777","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR_Building27Meter No.170772779","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR_Building24Meter No.47344754","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR_Building19Meter No.200425920","monthly",36,null,{"v":0,"d":"R0.00"}]
["CSIR_046FMeter No.15723503","monthly",36,null,{"v":0,"d":"R0.00"}]
[]
[]
["Sub Total",{"$nulls":3},{"$f":"SUM(E103:E191)","v":{"v":0,"d":"R0.00"}}]
[]
["Repots & Technical Support"]
[]
["Reporting (As per section 3.1 of the RFP)","sum",1,null,{"$f":"C198*D198","v":{"v":0,"d":"R0.00"}}]
["Operations/Technical Support  (As per section 3.1 of the RFP)","sum",1,null,{"v":0,"d":"R0.00"}]
[]
["Sub Total",null,{"$f":"SUM(C198:C199)","v":2},null,{"$f":"SUM(E198:E199)","v":{"v":0,"d":"R0.00"}}]

{"sheet":"Anex D.2_ JHB","index":2,"n_rows":22,"n_cols":5,"rows_kept":22}
["The provision of water management services to the CSIR  for a period of three (3) years"]
["CSIR - Johannesburg"]
[]
[]
["Description","Unit","Qty","Rate","Total"]
["Testing, configuration and linking of devices to the new platform"]
[]
["CSIR-Jhb-Cottlesloe   Meter No.12419258","sum",1,null,{"$f":"C8*D8","v":{"v":0,"d":"R0.00"}}]
["CSIR-Jhb- Carlow Road  Meter No.170772754","sum",1,null,{"v":0,"d":"R0.00"}]
["Sub Total",null,{"$f":"SUM(C8:C9)","v":2},null,{"$f":"SUM(E8:E9)","v":{"v":0,"d":"R0.00"}}]
[]
["Monthly Subscription fees (12x 3years)"]
[]
["CSIR-Jhb-Cottlesloe   Meter No.12419258","monthly",{"$f":"12*3","v":36},null,{"$f":"C14*D14","v":{"v":0,"d":"R0.00"}}]
["CSIR-Jhb- Carlow Road  Meter No.170772754","monthly",{"$f":"12*3","v":36},null,{"v":0,"d":"R0.00"}]
["Sub Total",{"$nulls":3},{"$f":"SUM(E14:E15)","v":{"v":0,"d":"R0.00"}}]
[]
["Repots & Technical Support"]
[]
["Reporting (As per section 3.1 of the RFP)","sum",1,null,{"$f":"C20*D20","v":{"v":0,"d":"R0.00"}}]
["Operations/Technical Support  (As per section 3.1 of the RFP)","sum",1,null,{"v":0,"d":"R0.00"}]
["Sub Total",null,{"$f":"SUM(C20:C21)","v":2},null,{"$f":"SUM(E20:E21)","v":{"v":0,"d":"R0.00"}}]

{"sheet":"Anex D.3_DUR","index":3,"n_rows":24,"n_cols":5,"rows_kept":24}
["The provision of water management services to the CSIR  for a period of three (3) years"]
["CSIR - Durban"]
[]
[]
["Description","Unit","Qty","Rate","Total"]
["Testing, configuration and linking of devices to the new platform"]
[]
["CSIR-Durban-Main Incomer    Meter No.16794648","sum",1,null,{"$f":"C8*D8","v":{"v":0,"d":"R0.00"}}]
[]
["Sub Total",null,1,null,{"$f":"SUM(E8:E9)","v":{"v":0,"d":"R0.00"}}]
[]
[]
["Monthly Subscription fees (12x 3years)"]
[]
["CSIR-Durban-Main Incomer    Meter No.16794648","monthly",{"$f":"12*3","v":36},null,{"$f":"C15*D15","v":{"v":0,"d":"R0.00"}}]
[]
["Sub Total",{"$nulls":3},{"$f":"SUM(E15:E16)","v":{"v":0,"d":"R0.00"}}]
[]
["Repots & Technical Support"]
[]
["Reporting (As per section 3.1 of the RFP)","sum",1,null,{"$f":"C21*D21","v":{"v":0,"d":"R0.00"}}]
["Operations/Technical Support  (As per section 3.1 of the RFP)","sum",1,null,{"v":0,"d":"R0.00"}]
[]
["Sub Total",null,{"$f":"SUM(C21:C22)","v":2},null,{"$f":"SUM(E22:E23)","v":{"v":0,"d":"R0.00"}}]

{"sheet":"Anex D.4_ Rosebank","index":4,"n_rows":26,"n_cols":5,"rows_kept":26}
["The provision of water management services to the CSIR  for a period of three (3) years"]
["CSIR - Rosebank"]
[]
[]
["Description","Unit","Qty","Rate","Total"]
["Testing, configuration and linking of devices to the new platform"]
[]
["CSIR Rosebank main meter  No.12UI056375        ","sum",1,null,{"$f":"C8*D8","v":{"v":0,"d":"R0.00"}}]
["CSIR-Rosebank  Building 8 Stables  Meter No.AJK-1068    ","sum",1,null,{"$f":"C9*D9","v":{"v":0,"d":"R0.00"}}]
[]
[]
["Sub Total",null,{"$f":"SUM(C8:C9)","v":2},null,{"$f":"SUM(E8:E9)","v":{"v":0,"d":"R0.00"}}]
[]
["Monthly Subscription fees (12x 3years)"]
[]
["CSIR Rosebank main meter  No.12UI056375        ","monthly",{"$f":"12*3","v":36},null,{"$f":"C16*D16","v":{"v":0,"d":"R0.00"}}]
["CSIR-Rosebank  Building 8 Stables  Meter No.AJK-1068    ","monthly",{"$f":"12*3","v":36},null,{"v":0,"d":"R0.00"}]
[]
["Sub Total",{"$nulls":3},{"$f":"SUM(E16:E17)","v":{"v":0,"d":"R0.00"}}]
[]
["Repots & Technical Support"]
[]
["Reporting (As per section 3.1 of the RFP)","sum",1,null,{"$f":"C23*D23","v":{"v":0,"d":"R0.00"}}]
["Operations/Technical Support  (As per section 3.1 of the RFP)","sum",1,null,{"v":0,"d":"R0.00"}]
[]
["Sub Total",null,{"$f":"SUM(C23:C24)","v":2},null,{"$f":"SUM(E23:E24)","v":{"v":0,"d":"R0.00"}}]

{"sheet":"Anex D.5_Stellenbosch","index":5,"n_rows":29,"n_cols":5,"rows_kept":29}
["The provision of water management services to the CSIR  for a period of three (3) years"]
["CSIR - Stellenbosch"]
[]
[]
["Description","Unit","Qty","Rate","Total"]
["Testing, configuration and linking of devices to the new platform"]
[]
["CSIR Stellenbosch D Block Meter  No.JJK0088","sum",1,null,{"$f":"C8*D8","v":{"v":0,"d":"R0.00"}}]
["CSIR-Stellenbosch-TSO  Meter No.1710936170        ","sum",1,null,{"$f":"C9*D9","v":{"v":0,"d":"R0.00"}}]
["CSIR-Stellenbosch-Municipal Bulk Meter No.16774637  ","sum",1,null,{"v":0,"d":"R0.00"}]
[]
[]
["Sub Total",null,{"$f":"SUM(C8:C11)","v":3},null,{"$f":"SUM(E8:E11)","v":{"v":0,"d":"R0.00"}}]
[]
["Monthly Subscription fees (12x 3years)"]
[]
["CSIR Stellenbosch D Block Meter  No.JJK0088","monthly",{"$f":"12*3","v":36},null,{"$f":"C17*D17","v":{"v":0,"d":"R0.00"}}]
["CSIR-Stellenbosch-TSO  Meter No.1710936170        ","monthly",{"$f":"12*3","v":36},null,{"v":0,"d":"R0.00"}]
["CSIR-Stellenbosch-Municipal Bulk Meter No.16774637  ","monthly",36,null,{"v":0,"d":"R0.00"}]
[]
[]
["Sub Total",{"$nulls":3},{"$f":"SUM(E17:E20)","v":{"v":0,"d":"R0.00"}}]
[]
["Repots & Technical Support"]
[]
["Reporting (As per section 3.1 of the RFP)","sum",1,null,{"$f":"C26*D26","v":{"v":0,"d":"R0.00"}}]
["Operations/Technical Support  (As per section 3.1 of the RFP)","sum",1,null,{"v":0,"d":"R0.00"}]
[]
["Sub Total",null,{"$f":"SUM(C26:C27)","v":2},null,{"$f":"SUM(E26:E27)","v":{"v":0,"d":"R0.00"}}]